IBM DB2 with BLU Acceleration
ثبت نشده
چکیده
Furthermore, BLU Acceleration is built directly into the DB2 kernel (see Figure 1). It is not just an additional feature; it is an integral part of DB2 and every part of DB2 is aware of it. BLU Acceleration still uses the same storage unit of pages, the same buffer pools, and the same backup and recovery mechanisms, so BLU Acceleration tables can coexist with traditional row tables in the same schema, storage, and memory, and you can query a mix of traditional row and BLU Acceleration tables at the same time.
منابع مشابه
Evolutionary Integration of In-Memory Database Technology into IBM's Enterprise DB2 Database Systems
Recently, IBM announced Blink Ultra (BLU) as an in-memory enhancement for DB2 for Linux, Unix, and Windows. The technology implemented in BLU was tested in various stages until it founds its current form as DB2 feature. In this paper, we give a brief summary on the origins of BLU and the adoption process from the BLINK prototype over the IBM Smart Analytics Optimizer to BLU itself.
متن کاملDB2 with BLU Acceleration: So Much More than Just a Column Store
DB2 with BLU Acceleration deeply integrates innovative new techniques for defining and processing column-organized tables that speed read-mostly Business Intelligence queries by 10 to 50 times and improve compression by 3 to 10 times, compared to traditional row-organized tables, without the complexity of defining indexes or materialized views on those tables. But DB2 BLU is much more than just...
متن کاملDB2 10.5 with BLU Acceleration - New Dynamic In-Memory Analytics for the Era of Big Data
Will reading habit influence your life? Many say yes. Reading db2 10 5 with blu acceleration new dynamic in memory analytics for the era of big data is a good habit; you can develop this habit to be such interesting way. Yeah, reading habit will not only make you have any favourite activity. It will be one of guidance of your life. When reading has become a habit, you will not make it as distur...
متن کاملIntegration of Spatial Data in Database Acceleration for Analytics
The IBM DB2 Analytics Accelerator (IDAA) integrates the strong OLTP capabilities of DB2 for z/OS with very fast processing of OLAP and analytical SQL workload in Netezza. Today, not all data types supported by DB2 are available for acceleration. One step to narrow this gap is to enable spatial data in form of polygons, linestrings, and points for OLAP processing. Since DB2 and Netezza have very...
متن کاملDemonstrating Near Real-Time Analytics with IBM DB2 Analytics Accelerator
Version 3 of the IBM DB2 Analytics Accelerator (IDAA) takes a major step towards the vision of a universal relational DBMS that transparently processes both, OLTP and analytical-type queries in a single system. Based on heuristics in DB2 for z/OS, the DB2 optimizer decides if a query should be executed by ”mainline” DB2 or if it is beneficial to forward it to the attached IBM DB2 Analytics Opti...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2014